Diagram CaseNote Tracking

Defincja diagramu CaseNote Tracking

Name

CaseNote Tracking

Code

CaseNote_Tracking

Comment

 


Lista tabel diagramu

Name

Code

CNFolder

CNFolder

CNStatus

CNStatus

CNStatusText

CNStatusText

CNTrackingInfo

CNTrackingInfo

ExternalIdentifier

ExternalIdentifier

IdentifierType

IdentifierType

IdentifierTypeText

IdentifierTypeText

Language

Language

LExternalIdentifierStatus

LExternalIdentifierStatus

LOrderIdentifier

LOrderIdentifier

LOrderStatus

LOrderStatus

OrderItem

OrderItem

OrderStatus

OrderStatus

Person

Person


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_25

R_25

Person

Person

Per_PersonID

 

 

R_46

R_46

IdentifierType

IdentifierTypeText

IdentifierTypeID

 

 

R_47

R_47

Language

IdentifierTypeText

LanguageID

 

 

R_48

R_48

IdentifierType

ExternalIdentifier

IdentifierTypeID

 

 

R_221

R_221

ExternalIdentifier

LOrderIdentifier

IdentifierTypeID; ExternalValue

 

 

R_224

R_224

OrderItem

LOrderIdentifier

OrderID

 

 

R_719

R_719

OrderItem

LOrderStatus

OrderID

 

 

R_720

R_720

OrderStatus

LOrderStatus

OrderStatusID

 

 

R_834

R_834

OrderStatus

LOrderIdentifier

OrderStatusID

 

 

R_848

R_848

OrderItem

CNTrackingInfo

OrderID

 

 

R_849

R_849

CNTrackingInfo

LExternalIdentifierStatus

CNTrackingInfoID

 

 

R_850

R_850

CNStatus

LExternalIdentifierStatus

CNStatusID

 

 

R_851

R_851

ExternalIdentifier

CNTrackingInfo

IdentifierTypeID; ExternalValue

 

 

R_852

R_852

CNStatus

ExternalIdentifier

CNStatusID

 

 

R_853

R_853

CNStatus

CNStatusText

CNStatusID

 

 

R_854

R_854

Language

CNStatusText

LanguageID

 

 

R_3050

R_3050

ExternalIdentifier

CNFolder

IdentifierTypeID; ExternalValue

 

 

R_3051

R_3051

CNFolder

ExternalIdentifier

CNFolderID